package com.yuanfengPlus.production.Mapper;

import com.yuanfengPlus.production.model.ProdEmployee;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface ProdEmployeesMapper {

    // 查询所有员工
    @Select("SELECT * FROM prod_employees")
    List<ProdEmployee> selectAll();

    // 根据员工ID查询员工
    @Select("SELECT * FROM prod_employees WHERE employee_id = #{employeeId}")
    ProdEmployee selectById(int employeeId);
}
